<?php require_once('../Connections/mlu.php');


$query_Recordset1riclibri = "select data,count(*) as conto from depositati group by data order by data";
 $Result1 = mysql_query($query_Recordset1riclibri, $mlu) or die(mysql_error()); ?>
<h1>MOVIMENTO LIBRI IN RICEZIONE </h1>
<table border="1">
  <tr>
  <th>data</th>
  <th>totale</th>
  </tr>
  <?php while ($row_Recordset1 = mysql_fetch_assoc($Result1))
  { ?>
	
    <tr>  
  <td><?php echo $row_Recordset1['data']; ?></td>
  <td><?php echo $row_Recordset1['conto']; ?></td>
  </tr>
  
  <?php }?>
  </table>
  
  
  
 <?php $query_Recordset1riclibri = "select count(*) as conto from depositati";
 $Result1 = mysql_query($query_Recordset1riclibri, $mlu) or die(mysql_error());
 $row_Recordset1 = mysql_fetch_assoc($Result1); ?>
 <h1>totale libri in ricezione: <?php echo $row_Recordset1['conto']; ?></h1>
 